/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 18:03:02
*/


-- ----------------------------
-- Table structure for tb2509
-- ----------------------------
DROP TABLE [dbo].[tb2509]
GO
CREATE TABLE [dbo].[tb2509] (
[EthnicID] varchar(20) NOT NULL ,
[EthnicName] nvarchar(50) NULL ,
[Disabled] tinyint NOT NULL DEFAULT((0)),
[CreateUserID] varchar(20) NOT NULL ,
[CreateDate] datetime NOT NULL DEFAULT (getdate()) ,
[LastModifyUserID] varchar(20) NOT NULL ,
[LastModifyDate] datetime NOT NULL DEFAULT (getdate()) 
)


GO

-- ----------------------------
-- Records of tb2509
-- ----------------------------
INSERT INTO [dbo].[tb2509] ([EthnicID], [EthnicName], [Disabled], [CreateUserID], [CreateDate], [LastModifyUserID], [LastModifyDate]) VALUES (N'MONG', N'MONG', N'0', N'admin', N'2011-07-29 17:55:57.717', N'admin', N'2011-07-29 17:55:57.717')
GO
GO
INSERT INTO [dbo].[tb2509] ([EthnicID], [EthnicName], [Disabled], [CreateUserID], [CreateDate], [LastModifyUserID], [LastModifyDate]) VALUES (N'KINH', N'KINH', N'0', N'admin', N'2011-07-29 17:55:51.483', N'admin', N'2011-07-29 17:55:51.483')
GO
GO

-- ----------------------------
-- Indexes structure for table tb2509
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb2509
-- ----------------------------
ALTER TABLE [dbo].[tb2509] ADD PRIMARY KEY NONCLUSTERED ([EthnicID])
GO
